[dbo].[BAEUpdateIMISShipMethod]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEUpdateIMISShipMethod

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@orderID	varchar(64)	64
@shipMethod	varchar(64)	64

SQL Script

create procedure [dbo].[BAEUpdateIMISShipMethod] @orderID varchar(64),
     @shipMethod varchar(64) as
begin
        UPDATE Orders
            SET SHIP_METHOD = @shipMethod
        WHERE ORDER_NUMBER = @orderID
    end

GO

Uses

[dbo].[Orders]
dbo